package com.dy.gmall2206a.mapper;

import com.dy.gmall2206a.bean.Province;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @projectName: gmalll2206
 * @package: com.dy.gmall2206a.mapper
 * @className: SugarMapper
 * @author: DuanYu
 * @description: TODO
 * @date: 2025/3/9 16:36
 * @version: 1.0
 */
@Mapper
public interface SugarMapper {
    @Select("select province_name as name ,sum(order_amount) as value from gmall2023_realtime.dws_trade_province_order_window " +
            "group by province_name")
    List<Province> showMap();
}
